create external table jms_ods.tab_stay_warning_config
   (
    id                       string,
    date_time                timestamp comment '运行日期',
        network_name             string comment '网点名称',
        network_code             string comment '网点编码',
        status                   tinyint comment '状态(0未生效,1已生效)',
        create_by_name           string comment '创建人名称',
        create_by_code           string comment '创建人code',
        create_time              TIMESTAMP comment '创建时间',
        update_time              TIMESTAMP comment '修改时间',
        update_by_name           string comment '修改人名称',
        update_by_code           string comment '修改人code',
        remark                   string comment '备注(预留字段)'
   )comment  '滞留预警配置表'
 PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
 STORED AS PARQUET
 LOCATION '/dw/hive/jms_ods.db/external/tab_stay_warning_config'
 TBLPROPERTIES (
 'discover.partitions'='false',
 'parquet.column.index.access'='true'
 );
